package cn.ecut.dzy.dao.impl;


import cn.ecut.dzy.dao.OrderItemDao;
import cn.ecut.dzy.pojo.OrderItem;

import java.util.List;

public class OrderItemDaoImpl extends BaseDao implements OrderItemDao {
    @Override
    public int saveOrderItem(OrderItem orderItem) {
        String sql = "insert into t_order_item(`name`,`count`,`price`,`total_price`,`order_id`) values(?,?,?,?,?)";
        return update(sql,orderItem.getName(),orderItem.getCount(),orderItem.getPrice(),orderItem.getTotalPrice(),orderItem.getOrderId());
    }

    @Override
    public List<OrderItem> queryOderItemByOrderId(String orderId) {
        String sql ="select id, name, count, price, total_price as totalPrice, order_id as orderId from t_order_item where order_id = ? ";
        return queryForList(OrderItem.class,sql,orderId);    }
}
